Go to HomeTreks Home




Note: Going home clears all of these panels.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.


Select
PackIt
Get
Food Supply Stock Budget

Operating and Capital Budget Calculation View

Capital Budget NPV Calculator

Introduction
This tool calculates net present value totals for operating and capital budget uris. The discounted totals include operating, allocated overhead, capital, and incentive-adjusted totals. Annual totals reflect the cost for operations or components that have an effective life different than 1 period.

Calculation View Description
v214a

Version: 1.7.0

Feedback About smallholders/investment/Food Supply Stock Budget/390/investment

Step 1 of 3. Make Selections


Step 2 of 3. Calculate

Relations

Use In Childs?
Overwrite Childs?

Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.



Instructions (beta)

Step 1

  • Step 1. Real and Nominal Rates: The nominal rate includes inflation while the real rate does not. In the USA, DevTreks recommends using Office of Management and Budget rates for the same year as the date of the input.

Step 2

  • Step 2. Use Same Calculator Pack In Descendants?: True to insert or update this same calculator in children.
  • Step 3. Overwrite Descendants?: True to insert or update all of the attributes of this same calculator in all children. False only updates children attributes that are controlled by the developer of this calculator (i.e. version, stylehsheet name, relatedcalculatorstype ...)
  • Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
  • Step 2. Related Calculators Type: When the Use Same Calculator Pack in Descendant is true, uses this value to determine which descendant calculator to update. Inserts a new descendant when no descendant has this same name. Updates the descendant that has this same name.
  • Step 2. Alternative Type: This property is used to analyze differences between Alternatives.
  • Step 2. Target Type: This property is used to analyze progress being achieved with budget goals.
  • Step 2. Calculated Results: Please refer to the references below.

References

  • Hallam, Eidman, Morehart and Klonsky (editors) Commodity Cost and Returns Estimation Handbook, Staff General Research Papers, Iowa State University, Department of Economics, 1999

Current view of document
Food Supply Stock Budget
Investment Group : Food Nutrition, Stock Budgets
Document Status : underrevision
Description : Sample data used to test food nutrient analyzers.
Label : SR100 Investment Type : 38
Date : 12/31/2009 12:00:00 AM Last Changed : 12/31/2009 12:00:00 AM
Investment :Food Supply Stock Budget
Label 1 Label 2 Last Modif. Init. Value Salv. Value Interest Rates Nom. Rate Real Rate
SR100 none 12/31/2013 12:00:00 AM 0.0000 0.0000 0.0300 0.0100
Description
Sample data used to test food nutrient analyzers.
Time Period : 2011 Food Stock
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2011 True True 1 each 0 0
Time Period 2011 Food Stock Last Changed 6/12/2014 12:00:00 AM
Description
Sample data used to test food nutrient analyzers.
Label none Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : 2011 Food Produced SR01
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2011 SR01 1 each 1 0.0000 0.0000 0
Description
Sample data used to test calculations and analyses.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : 2011 BARLEY, PEARLED, RAW Label : 11351
1 1 each 1 1 cup 0.0900 0.09
Description
Sample USDA ARS data used to test outputs and outcomes.
Interest 0.00
6/11/2011 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.09
Output : 2011 POTATO, FLESH and SKN, RAW Label : 11352
1 1 each 1 1 potato, large (3in to 4-1-4in dia) 0.2000 0.20
Description
1 large 3 to 4 inch diameter potato
Interest 0.00
6/11/2011 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.20
Benefit Interest - Outcome 0.00 0.00
Total Benefit - Outcome 0.29 0.29
Total Incentive-Adjusted Benefits - Outcome 0.29 0.29
Totals Annual Totals
Total Benefit -Time Period 0.29 0.29
Total Incentive Ben -Time Period 0.29 0.29
Costs
Component : 2011 Food Subsistence BM SRO1
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2011 SR01 1 each 1 0.0000 0.0000 0
Description
Sample data used to test food nutrition calculations and analysis.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2011 BARLEY,PEARLED,RAW Label : 20005
09/01/2011 1 False 0 0.25 cup 0.1900 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 2 cups 1.5000 1.50
Incentive 0.0000 0 1.51
Description
Barley, pearled, raw
Input : 2011 POTATO,FLESH and SKN,RAW Label : 11352
09/01/2011 1 False 0 1 potato, large (3in to 4-1-4in dia) 0.1400 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 25 potatoes 3.5000 3.50
Incentive 0.0000 0 3.53
Description
Potato, flesh and skin, raw
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.05 0.05
Total Capital Costs - Component 5.05 5.05
Total Incentive-Adjusted Costs - Component 5.05 5.05
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 0.29 0.29
Allocated Overhead Costs (AOH)
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 0.29 0.29
Capital Costs (CAP)
Total Capital Costs -Time Period 5.05 5.05
Net Returns -Time Period -4.76 -4.76
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 5.05 5.05
Net Incentive Returns -Time Period -4.76 -4.76
Time Period : 2012 Food Stock
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2012 False True 1 none 0 0
Time Period 2012 Food Stock Last Changed 6/12/2014 12:00:00 AM
Description
Sample data used to test food nutrient analyzers.
Label none Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : 2012 Food Produced SR01
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2012 SR01 1 each 1 0.0000 0.0000 0
Description
Sample data used to test calculations and analyses.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : 2012 BARLEY, PEARLED, RAW Label : 11352
1 1 each 1 1.25 cup 0.0900 0.09
Description
Sample USDA ARS data used to test outputs and outcomes.
Interest 0.00
6/11/2012 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.09
Output : 2012 POTATO, FLESH and SKN, RAW Label : 11351
1 1 each 1 2 potato, large (3in to 4-1-4in dia) 0.4400 0.44
Description
1 large 3 to 4 inch diameter potato
Interest 0.00
6/11/2012 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.44
Benefit Interest - Outcome -0.01 -0.01
Total Benefit - Outcome 0.52 0.52
Total Incentive-Adjusted Benefits - Outcome 0.52 0.52
Totals Annual Totals
Total Benefit -Time Period 0.52 0.52
Total Incentive Ben -Time Period 0.52 0.52
Costs
Component : 2012 Food Subsistence BM SRO1
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2012 SR01 1 each 1 0.0000 0.0000 0
Description
Sample data used to test food nutrition calculations and analysis.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2012 BARLEY,PEARLED,RAW Label : 20005
09/01/2012 1 False 0 0.3 cup 0.2500 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 2 cups 1.6500 1.65
Incentive 0.0000 0 1.63
Description
Barley, pearled, raw
Input : 2012 POTATO,FLESH and SKN,RAW Label : 11352
09/01/2012 1 False 0 1.5 potato, large (3in to 4-1-4in dia) 0.2300 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 25 potatoes 3.8000 3.80
Incentive 0.0000 0 3.76
Description
Potato, flesh and skin, raw
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest -0.05 -0.05
Total Capital Costs - Component 5.40 5.40
Total Incentive-Adjusted Costs - Component 5.40 5.40
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 0.52 0.52
Allocated Overhead Costs (AOH)
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 0.52 0.52
Capital Costs (CAP)
Total Capital Costs -Time Period 5.40 5.40
Net Returns -Time Period -4.88 -4.87
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 5.40 5.40
Net Incentive Returns -Time Period -4.88 -4.87
Time Period : 2013 Food Stock
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2013 False True 1 none 0 0
Time Period 2013 Food Stock Last Changed 6/12/2014 12:00:00 AM
Description
Sample data used to test food nutrient analyzers.
Label none Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : 2013 Food Produced SR01
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2013 SR01 1 each 1 0.0000 0.0000 0
Description
Sample data used to test calculations and analyses.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : 2013 BARLEY, PEARLED, RAW Label : 11351
1 1 each 1 1.3 cup 0.1300 0.13
Description
Sample USDA ARS data used to test outputs and outcomes.
Interest 0.00
6/11/2013 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.13
Output : 2013 POTATO, FLESH and SKN, RAW Label : 11352
1 1 each 1 2 potato, large (3in to 4-1-4in dia) 0.4800 0.48
Description
1 large 3 to 4 inch diameter potato
Interest -0.01
6/11/2013 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.47
Benefit Interest - Outcome -0.01 -0.01
Total Benefit - Outcome 0.60 0.60
Total Incentive-Adjusted Benefits - Outcome 0.60 0.60
Totals Annual Totals
Total Benefit -Time Period 0.60 0.60
Total Incentive Ben -Time Period 0.60 0.60
Costs
Component : 2013 Food Subsistence BM SRO1
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2013 SR01 1 each 1 0.0000 0.0000 0
Description
Sample data used to test food nutrition calculations and analysis.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2013 BARLEY,PEARLED,RAW Label : 20005
09/01/2013 1 False 0 0.3 cup 0.2600 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 2 cups 1.7500 1.75
Incentive 0.0000 0 1.72
Description
Barley, pearled, raw
Input : 2013 POTATO,FLESH and SKN,RAW Label : 11352
09/01/2013 1 False 0 2 potato, large (3in to 4-1-4in dia) 0.3200 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 25 potatoes 4.0000 4.00
Incentive 0.0000 0 3.92
Description
Potato, flesh and skin, raw
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest -0.11 -0.11
Total Capital Costs - Component 5.64 5.64
Total Incentive-Adjusted Costs - Component 5.64 5.64
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 0.60 0.60
Allocated Overhead Costs (AOH)
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 0.60 0.60
Capital Costs (CAP)
Total Capital Costs -Time Period 5.64 5.64
Net Returns -Time Period -5.04 -5.04
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 5.64 5.64
Net Incentive Returns -Time Period -5.04 -5.04
Investment Totals and Nets Totals Annual Totals
Total Benefit -Investment 1.42 1.42
Total Operating Costs -Investment 0.00 0.00
Net Operating Returns -Investment 1.42 1.42
Total Allocated Overhead Costs -Investment 0.00 0.00
Net Operating and Overhead Returns -Investment 1.42 1.42
Total Capital Expenditure Costs -Investment 16.08 16.08
Net Returns -Investment -14.66 -14.66
Equivalent Annual Annuity -Investment -4.99
Total Incentive Ben -Investment 1.42 1.42
Total Incentive Costs -Investment 16.08 16.08
Net Incentive Returns -Investment -14.66 -14.66
Dataset: Food Supply Stock Budget IRI Sample data used to test food nutrient analyzers.

Search IRIs:
https://www.devtreks.org/hometreks/linkedviews/smallholders/investment/Food Supply Stock Budget/390/investment









Uploading a new file will replace any existing file. If necessary, please package and download the existing file prior to this action. If the file has been uploaded successfully, this page will refresh and show the new file information. If the file can't be uploaded (i.e. exceeds 60MB, unsupported mimetype, bad xml, bad html) this page will refresh and show the existing file information.

The file has been uploaded.